Dataset info
| Number of variables | 21 |
|---|---|
| Number of observations | 946820 |
| Missing cells | 18 (< 0.1%) |
| Duplicate rows | 32964 (3.5%) |
| Total size in memory | 151.7 MiB |
| Average record size in memory | 168.0 B |
Variables types
| Numeric | 9 |
|---|---|
| Categorical | 2 |
| Boolean | 8 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 0 |
| Rejected | 2 |
| Unsupported | 0 |
Warnings
| Dataset has 32964 (3.5%) duplicate rows | Warning |
amount has 10740 (1.1%) zeros | Zeros |
domain1 has a high cardinality: 9810 distinct values | Warning |
field1 has 101470 (10.7%) zeros | Zeros |
field5 has 586120 (61.9%) zeros | Zeros |
flag5 is highly skewed (γ1 = 25.44446999) | Skewed |
hour1 has 20020 (2.1%) zeros | Zeros |
hour2 is highly correlated with hour1 (ρ = 0.9947080158) | Rejected |
state1 has a high cardinality: 53 distinct values | Warning |
total is highly correlated with amount (ρ = 0.9994216775) | Rejected |
amount
Numeric
| Distinct count | 88 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 25.6353121 |
|---|---|
| Minimum | 0 |
| Maximum | 95.4 |
| Zeros (%) | 1.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 10.36 |
| Q1 | 12.95 |
| Median | 25.9 |
| Q3 | 38.85 |
| 95-th percentile | 49.95 |
| Maximum | 95.4 |
| Range | 95.4 |
| Interquartile range | 25.9 |
Descriptive statistics
| Standard deviation | 14.19041741 |
|---|---|
| Coef of variation | 0.5535496253 |
| Kurtosis | -1.154029748 |
| Mean | 25.6353121 |
| MAD | 13.17173095 |
| Skewness | 0.3167990242 |
| Sum | 24272026.2 |
| Variance | 201.3679462 |
| Memory size | 7.2 MiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[ 0. 4.75 9.605 9.995 10.18 ... 64.875 78.135 84.95 92.7 95.4 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 12.95 | 339070 | 35.8% | |
| 38.85 | 305980 | 32.3% | |
| 10.36 | 72450 | 7.7% | |
| 49.95 | 61200 | 6.5% | |
| 25.9 | 49670 | 5.2% | |
| 31.08 | 34080 | 3.6% | |
| 11.01 | 26970 | 2.8% | |
| 0 | 10740 | 1.1% | |
| 20.72 | 9940 | 1.0% | |
| 59.4 | 7430 | 0.8% | |
| Other values (78) | 29290 | 3.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 10740 | 1.1% | |
| 9.5 | 120 | < 0.1% | |
| 9.71 | 220 | < 0.1% | |
| 9.99 | 100 | < 0.1% | |
| 10 | 20 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 95.4 | 290 | < 0.1% | |
| 90 | 70 | < 0.1% | |
| 89.95 | 90 | < 0.1% | |
| 79.95 | 60 | < 0.1% | |
| 76.32 | 10 | < 0.1% |
df_index
Numeric
| Distinct count | 85214 |
|---|---|
| Unique (%) | 9.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 38819.12 |
|---|---|
| Minimum | 0 |
| Maximum | 85213 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2367 |
| Q1 | 14202 |
| Median | 37872 |
| Q3 | 61543 |
| 95-th percentile | 80479 |
| Maximum | 85213 |
| Range | 85213 |
| Interquartile range | 47341 |
Descriptive statistics
| Standard deviation | 25970.05113 |
|---|---|
| Coef of variation | 0.6690015416 |
| Kurtosis | -1.284262532 |
| Mean | 38819.12 |
| MAD | 22733.1482 |
| Skewness | 0.1256088471 |
| Sum | 3.67547192e+10 |
| Variance | 674443555.5 |
| Memory size | 7.2 MiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[ 0. 9467.5 85213. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 2047 | 20 | < 0.1% | |
| 4396 | 20 | < 0.1% | |
| 7981 | 20 | < 0.1% | |
| 5932 | 20 | < 0.1% | |
| 3375 | 20 | < 0.1% | |
| 1326 | 20 | < 0.1% | |
| 7469 | 20 | < 0.1% | |
| 5420 | 20 | < 0.1% | |
| 2863 | 20 | < 0.1% | |
| 814 | 20 | < 0.1% | |
| Other values (85204) | 946620 | > 99.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 20 | < 0.1% | |
| 1 | 20 | < 0.1% | |
| 2 | 20 | < 0.1% | |
| 3 | 20 | < 0.1% | |
| 4 | 20 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 85213 | 8 | < 0.1% | |
| 85212 | 10 | < 0.1% | |
| 85211 | 10 | < 0.1% | |
| 85210 | 10 | < 0.1% | |
| 85209 | 10 | < 0.1% |
domain1
Categorical
| Distinct count | 9810 |
|---|---|
| Unique (%) | 1.0% |
| Missing (%) | < 0.1% |
| Missing (n) | 10 |
| AOL.COM | |
|---|---|
| YAHOO.COM | |
| HOTMAIL.COM | |
| Other values (9806) |
| Value | Count | Frequency (%) | |
| AOL.COM | 164510 | 17.4% | |
| YAHOO.COM | 158140 | 16.7% | |
| HOTMAIL.COM | 115440 | 12.2% | |
| MSN.COM | 40290 | 4.3% | |
| COMCAST.NET | 39180 | 4.1% | |
| SBCGLOBAL.NET | 24980 | 2.6% | |
| COX.NET | 21640 | 2.3% | |
| EARTHLINK.NET | 20890 | 2.2% | |
| BELLSOUTH.NET | 16990 | 1.8% | |
| VERIZON.NET | 10250 | 1.1% | |
| Other values (9799) | 334500 | 35.3% |
| Max length | 38 |
|---|---|
| Mean length | 10.25557128 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
field1
Numeric
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.419203228 |
|---|---|
| Minimum | 0 |
| Maximum | 4 |
| Zeros (%) | 10.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| Median | 3 |
| Q3 | 3 |
| 95-th percentile | 3 |
| Maximum | 4 |
| Range | 4 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 1.003755571 |
|---|---|
| Coef of variation | 0.414911637 |
| Kurtosis | 1.012088836 |
| Mean | 2.419203228 |
| MAD | 0.7940265171 |
| Skewness | -1.3232963 |
| Sum | 2290550 |
| Variance | 1.007525247 |
| Memory size | 7.2 MiB |
Histogram with fixed size bins (bins=5)
| Value | Count | Frequency (%) | |
| 3 | 550020 | 58.1% | |
| 2 | 238030 | 25.1% | |
| 0 | 101470 | 10.7% | |
| 4 | 35710 | 3.8% | |
| 1 | 21590 | 2.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 101470 | 10.7% | |
| 1 | 21590 | 2.3% | |
| 2 | 238030 | 25.1% | |
| 3 | 550020 | 58.1% | |
| 4 | 35710 | 3.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 4 | 35710 | 3.8% | |
| 3 | 550020 | 58.1% | |
| 2 | 238030 | 25.1% | |
| 1 | 21590 | 2.3% | |
| 0 | 101470 | 10.7% |
field2
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 543890 | 57.4% | |
| 1 | 402930 | 42.6% |
field3
Numeric
| Distinct count | 15786 |
|---|---|
| Unique (%) | 1.7% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 714.5126529 |
|---|---|
| Minimum | -32265 |
| Maximum | 8193 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | -32265 |
|---|---|
| 5-th percentile | -6572 |
| Q1 | -1551 |
| Median | 1455 |
| Q3 | 3598 |
| 95-th percentile | 5859 |
| Maximum | 8193 |
| Range | 40458 |
| Interquartile range | 5149 |
Descriptive statistics
| Standard deviation | 3919.306449 |
|---|---|
| Coef of variation | 5.485286276 |
| Kurtosis | 1.008788952 |
| Mean | 714.5126529 |
| MAD | 3104.705182 |
| Skewness | -0.899935895 |
| Sum | 676514870 |
| Variance | 15360963.04 |
| Memory size | 7.2 MiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[-32265. -27037.5 -20615. -19523. -19305.5 ... 8088.5 8092.5 8137.5 8144.5 8193. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| -5437 | 1040 | 0.1% | |
| 249 | 770 | 0.1% | |
| -956 | 760 | 0.1% | |
| 1022 | 750 | 0.1% | |
| 1086 | 740 | 0.1% | |
| 30 | 720 | 0.1% | |
| 1623 | 670 | 0.1% | |
| 3340 | 600 | 0.1% | |
| 2634 | 580 | 0.1% | |
| 3330 | 550 | 0.1% | |
| Other values (15776) | 939640 | 99.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -32265 | 10 | < 0.1% | |
| -30554 | 50 | < 0.1% | |
| -23521 | 10 | < 0.1% | |
| -21927 | 10 | < 0.1% | |
| -21705 | 10 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 8193 | 10 | < 0.1% | |
| 8148 | 10 | < 0.1% | |
| 8141 | 20 | < 0.1% | |
| 8138 | 10 | < 0.1% | |
| 8137 | 10 | < 0.1% |
field4
Numeric
| Distinct count | 38 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 13.98411525 |
|---|---|
| Minimum | 6 |
| Maximum | 46 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 8 |
| Median | 12 |
| Q3 | 19 |
| 95-th percentile | 25 |
| Maximum | 46 |
| Range | 40 |
| Interquartile range | 11 |
Descriptive statistics
| Standard deviation | 6.516819922 |
|---|---|
| Coef of variation | 0.4660158906 |
| Kurtosis | -0.6524030389 |
| Mean | 13.98411525 |
| MAD | 5.752905436 |
| Skewness | 0.6164478364 |
| Sum | 13240440 |
| Variance | 42.46894189 |
| Memory size | 7.2 MiB |
Histogram with fixed size bins (bins=38)
Histogram with variable size bins (bins=[ 6. 6.5 7.5 8.5 9.5 ... 37.5 38.5 39.5 40.5 46. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 9 | 127010 | 13.4% | |
| 8 | 99280 | 10.5% | |
| 7 | 79670 | 8.4% | |
| 10 | 65140 | 6.9% | |
| 6 | 61340 | 6.5% | |
| 18 | 44100 | 4.7% | |
| 20 | 43110 | 4.6% | |
| 21 | 40140 | 4.2% | |
| 19 | 40090 | 4.2% | |
| 11 | 38840 | 4.1% | |
| Other values (28) | 308100 | 32.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 6 | 61340 | 6.5% | |
| 7 | 79670 | 8.4% | |
| 8 | 99280 | 10.5% | |
| 9 | 127010 | 13.4% | |
| 10 | 65140 | 6.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 46 | 10 | < 0.1% | |
| 42 | 10 | < 0.1% | |
| 41 | 10 | < 0.1% | |
| 40 | 30 | < 0.1% | |
| 39 | 70 | < 0.1% |
field5
Numeric
| Distinct count | 26 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.375689149 |
|---|---|
| Minimum | 0 |
| Maximum | 26 |
| Zeros (%) | 61.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 2 |
| 95-th percentile | 9 |
| Maximum | 26 |
| Range | 26 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 2.423929687 |
|---|---|
| Coef of variation | 1.761974854 |
| Kurtosis | 6.183346695 |
| Mean | 1.375689149 |
| MAD | 1.761011311 |
| Skewness | 2.291718656 |
| Sum | 1302530 |
| Variance | 5.875435128 |
| Memory size | 7.2 MiB |
Histogram with fixed size bins (bins=26)
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 21.5 22.5 23.5 24.5 26. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 586120 | 61.9% | |
| 2 | 95220 | 10.1% | |
| 1 | 72830 | 7.7% | |
| 4 | 67500 | 7.1% | |
| 9 | 52460 | 5.5% | |
| 3 | 48880 | 5.2% | |
| 5 | 11270 | 1.2% | |
| 6 | 7540 | 0.8% | |
| 8 | 1700 | 0.2% | |
| 7 | 1680 | 0.2% | |
| Other values (16) | 1620 | 0.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 586120 | 61.9% | |
| 1 | 72830 | 7.7% | |
| 2 | 95220 | 10.1% | |
| 3 | 48880 | 5.2% | |
| 4 | 67500 | 7.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 26 | 20 | < 0.1% | |
| 25 | 50 | < 0.1% | |
| 24 | 10 | < 0.1% | |
| 23 | 130 | < 0.1% | |
| 22 | 30 | < 0.1% |
flag1
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 517900 | 54.7% | |
| 0 | 428920 | 45.3% |
flag2
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 512350 | 54.1% | |
| 0 | 434470 | 45.9% |
flag3
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 566970 | 59.9% | |
| 1 | 379850 | 40.1% |
flag4
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 18830 |
| Value | Count | Frequency (%) | |
| 0 | 927990 | 98.0% | |
| 1 | 18830 | 2.0% |
flag5
Numeric
| Distinct count | 36 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 6.176675609 |
|---|---|
| Minimum | 0 |
| Maximum | 3278 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 3278 |
| Range | 3278 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 102.9769538 |
|---|---|
| Coef of variation | 16.67190578 |
| Kurtosis | 714.8784431 |
| Mean | 6.176675609 |
| MAD | 9.72390082 |
| Skewness | 25.44446999 |
| Sum | 5848200 |
| Variance | 10604.253 |
| Memory size | 7.2 MiB |
Histogram with fixed size bins (bins=36)
Histogram with variable size bins (bins=[0.0000e+00 5.0000e-01 1.5000e+00 2.5000e+00 3.5000e+00 ... 1.2095e+03 1.5170e+03 1.6215e+03 2.4605e+03 3.2780e+03], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 1 | 724150 | 76.5% | |
| 2 | 176920 | 18.7% | |
| 3 | 30750 | 3.2% | |
| 4 | 6770 | 0.7% | |
| 5 | 1960 | 0.2% | |
| 6 | 990 | 0.1% | |
| 1600 | 950 | 0.1% | |
| 7 | 760 | 0.1% | |
| 3278 | 590 | 0.1% | |
| 364 | 480 | 0.1% | |
| Other values (26) | 2500 | 0.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 140 | < 0.1% | |
| 1 | 724150 | 76.5% | |
| 2 | 176920 | 18.7% | |
| 3 | 30750 | 3.2% | |
| 4 | 6770 | 0.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3278 | 590 | 0.1% | |
| 1643 | 280 | < 0.1% | |
| 1600 | 950 | 0.1% | |
| 1434 | 110 | < 0.1% | |
| 985 | 20 | < 0.1% |
fraud
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 8 |
| 0 | |
|---|---|
| 1 | 19950 |
| (Missing) | 8 |
| Value | Count | Frequency (%) | |
| 0 | 926862 | 97.9% | |
| 1 | 19950 | 2.1% | |
| (Missing) | 8 | < 0.1% |
hour1
Numeric
| Distinct count | 24 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 13.86472614 |
|---|---|
| Minimum | 0 |
| Maximum | 23 |
| Zeros (%) | 2.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 10 |
| Median | 14 |
| Q3 | 18 |
| 95-th percentile | 22 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range | 8 |
Descriptive statistics
| Standard deviation | 5.263208162 |
|---|---|
| Coef of variation | 0.3796114045 |
| Kurtosis | -0.02842532144 |
| Mean | 13.86472614 |
| MAD | 4.22002196 |
| Skewness | -0.4351781733 |
| Sum | 13127400 |
| Variance | 27.70136016 |
| Memory size | 7.2 MiB |
Histogram with fixed size bins (bins=24)
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 19.5 20.5 21.5 22.5 23. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 13 | 70560 | 7.5% | |
| 14 | 68250 | 7.2% | |
| 12 | 67380 | 7.1% | |
| 11 | 66920 | 7.1% | |
| 15 | 64780 | 6.8% | |
| 10 | 60840 | 6.4% | |
| 16 | 60200 | 6.4% | |
| 17 | 56630 | 6.0% | |
| 18 | 51940 | 5.5% | |
| 9 | 50320 | 5.3% | |
| Other values (14) | 329000 | 34.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 20020 | 2.1% | |
| 1 | 12750 | 1.3% | |
| 2 | 7490 | 0.8% | |
| 3 | 5280 | 0.6% | |
| 4 | 4750 | 0.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 23 | 28160 | 3.0% | |
| 22 | 35160 | 3.7% | |
| 21 | 42350 | 4.5% | |
| 20 | 47940 | 5.1% | |
| 19 | 49570 | 5.2% |
hour2
Highly correlated
This variable is highly correlated with hour1 and should be ignored for analysis
| Correlation | 0.9947080158 |
|---|
indicator1
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 107280 |
| Value | Count | Frequency (%) | |
| 0 | 839540 | 88.7% | |
| 1 | 107280 | 11.3% |
indicator2
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 17390 |
| Value | Count | Frequency (%) | |
| 0 | 929430 | 98.2% | |
| 1 | 17390 | 1.8% |
state1
Categorical
| Distinct count | 53 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| CA | |
|---|---|
| FL | 84360 |
| TX | 66200 |
| Other values (50) |
| Value | Count | Frequency (%) | |
| CA | 186760 | 19.7% | |
| FL | 84360 | 8.9% | |
| TX | 66200 | 7.0% | |
| NY | 57950 | 6.1% | |
| GA | 44790 | 4.7% | |
| VA | 37030 | 3.9% | |
| IL | 36040 | 3.8% | |
| AZ | 32360 | 3.4% | |
| MD | 26710 | 2.8% | |
| NJ | 26600 | 2.8% | |
| Other values (43) | 348020 | 36.8% |
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
total
Highly correlated
This variable is highly correlated with amount and should be ignored for analysis
| Correlation | 0.9994216775 |
|---|
zip1
Numeric
| Distinct count | 899 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 543.2437422 |
|---|---|
| Minimum | 2 |
| Maximum | 999 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 76 |
| Q1 | 282 |
| Median | 530 |
| Q3 | 891 |
| 95-th percentile | 956 |
| Maximum | 999 |
| Range | 997 |
| Interquartile range | 609 |
Descriptive statistics
| Standard deviation | 315.3723025 |
|---|---|
| Coef of variation | 0.580535546 |
| Kurtosis | -1.508401046 |
| Mean | 543.2437422 |
| MAD | 288.6651076 |
| Skewness | -0.0288278305 |
| Sum | 514354040 |
| Variance | 99459.68918 |
| Memory size | 7.2 MiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[ 2. 4. 6.5 8.5 9.5 ... 993.5 994.5 995.5 997.5 999. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 300 | 16180 | 1.7% | |
| 945 | 15800 | 1.7% | |
| 852 | 12290 | 1.3% | |
| 926 | 12010 | 1.3% | |
| 606 | 11480 | 1.2% | |
| 750 | 11020 | 1.2% | |
| 900 | 10690 | 1.1% | |
| 100 | 9840 | 1.0% | |
| 331 | 9820 | 1.0% | |
| 921 | 9660 | 1.0% | |
| Other values (889) | 828030 | 87.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2 | 30 | < 0.1% | |
| 6 | 110 | < 0.1% | |
| 7 | 90 | < 0.1% | |
| 8 | 100 | < 0.1% | |
| 9 | 260 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 999 | 90 | < 0.1% | |
| 998 | 230 | < 0.1% | |
| 997 | 550 | 0.1% | |
| 996 | 500 | 0.1% | |
| 995 | 1350 | 0.1% |
First rows
| amount | df_index | domain1 | field1 | field2 | field3 | field4 | field5 | flag1 | flag2 | flag3 | flag4 | flag5 | fraud | hour1 | hour2 | indicator1 | indicator2 | state1 | total | zip1 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 25.90 | 0 | BELLSOUTH.NET | 3 | 1 | 3878 | 8 | 0 | 1 | 0 | 1 | 0 | 1 | 0.0 | 0 | 0 | 0 | 0 | FL | 25.90 | 331 |
| 1 | 38.85 | 1 | COMCAST.NET | 2 | 1 | -6330 | 21 | 1 | 0 | 1 | 1 | 0 | 1 | 0.0 | 0 | 0 | 0 | 0 | TX | 38.85 | 750 |
| 2 | 38.85 | 2 | HOTMAIL.COM | 2 | 0 | 5183 | 19 | 1 | 0 | 0 | 0 | 0 | 1 | 0.0 | 1 | 1 | 0 | 0 | VA | 38.85 | 222 |
| 3 | 24.95 | 3 | GMAIL.COM | 0 | 0 | 3822 | 16 | 0 | 0 | 0 | 0 | 0 | 1 | 0.0 | 1 | 1 | 0 | 0 | CA | 24.95 | 946 |
| 4 | 20.72 | 4 | LEVEL3.COM | 3 | 0 | 3536 | 8 | 1 | 1 | 1 | 1 | 0 | 1 | 0.0 | 1 | 1 | 0 | 0 | CO | 20.72 | 805 |
| 5 | 12.95 | 5 | AOL.COM | 2 | 1 | 6110 | 17 | 2 | 0 | 0 | 0 | 0 | 1 | 0.0 | 3 | 3 | 1 | 0 | AZ | 12.95 | 857 |
| 6 | 10.36 | 6 | AOL.COM | 2 | 0 | 779 | 10 | 1 | 1 | 1 | 1 | 1 | 2 | 0.0 | 5 | 5 | 0 | 0 | NY | 10.36 | 112 |
| 7 | 10.36 | 7 | HOTMAIL.COM | 2 | 0 | -5435 | 8 | 0 | 1 | 1 | 1 | 1 | 2 | 0.0 | 5 | 5 | 0 | 0 | PA | 10.36 | 152 |
| 8 | 10.36 | 8 | AOL.COM | 2 | 0 | 5856 | 9 | 4 | 1 | 1 | 1 | 0 | 4 | 0.0 | 6 | 6 | 0 | 0 | GA | 10.36 | 301 |
| 9 | 38.85 | 9 | SBCGLOBAL.NET | 2 | 1 | 542 | 27 | 0 | 1 | 1 | 0 | 0 | 1 | 0.0 | 7 | 7 | 0 | 0 | CA | 38.85 | 956 |
Last rows
| amount | df_index | domain1 | field1 | field2 | field3 | field4 | field5 | flag1 | flag2 | flag3 | flag4 | flag5 | fraud | hour1 | hour2 | indicator1 | indicator2 | state1 | total | zip1 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 946810 | 39.96 | 85204 | COX.NET | 0 | 1 | -2284 | 17 | 0 | 0 | 1 | 1 | 0 | 1 | 0.0 | 14 | 14 | 0 | 0 | CA | 39.96 | 926 |
| 946811 | 39.96 | 85205 | COX.NET | 0 | 1 | -2284 | 17 | 0 | 0 | 1 | 1 | 0 | 1 | 0.0 | 14 | 14 | 0 | 0 | CA | 39.96 | 926 |
| 946812 | 12.95 | 85206 | HOTMAIL.COM | 3 | 0 | 5229 | 11 | 0 | 1 | 0 | 0 | 0 | 1 | 1.0 | 16 | 16 | 1 | 0 | KS | 12.95 | 670 |
| 946813 | 38.85 | 85207 | AOL.COM | 3 | 1 | -1317 | 8 | 2 | 0 | 1 | 1 | 0 | 4 | 1.0 | 20 | 20 | 0 | 0 | AZ | 38.85 | 850 |
| 946814 | 12.95 | 85208 | AOL.COM | 3 | 1 | -1317 | 8 | 2 | 0 | 1 | 1 | 0 | 4 | 0.0 | 20 | 20 | 0 | 0 | AZ | 12.95 | 850 |
| 946815 | 38.85 | 85209 | AOL.COM | 3 | 1 | -5821 | 6 | 2 | 0 | 1 | 1 | 0 | 3 | 0.0 | 20 | 20 | 0 | 0 | MI | 38.85 | 481 |
| 946816 | 12.95 | 85210 | HOTMAIL.COM | 2 | 0 | 182 | 9 | 9 | 1 | 1 | 1 | 0 | 1 | 1.0 | 16 | 16 | 0 | 0 | GA | 12.95 | 300 |
| 946817 | 38.85 | 85211 | AOL.COM | 2 | 1 | -2914 | 8 | 2 | 0 | 1 | 1 | 0 | 3 | 1.0 | 5 | 5 | 0 | 0 | CA | 38.85 | 906 |
| 946818 | 38.85 | 85212 | AOL.COM | 2 | 0 | 1530 | 7 | 2 | 0 | 1 | 1 | 0 | 1 | 1.0 | 6 | 6 | 0 | 0 | NY | 38.85 | 105 |
| 946819 | 38.85 | 85213 | AOL.COM | 2 | 0 | -676 | 8 | 2 | 0 | 1 | 1 | 0 | 4 | NaN | 19 | 19 | 0 | 0 | AZ | 38.85 | 857 |